Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$BUFFERED_SUBSCRIBERS

`V$BUFFERED_SUBSCRIBERS` displays information about the subscribers for all buffered queues in the instance. There is one row per subscriber per queue.

Column | Datatype | Description
--- | --- | ---
`QUEUE_ID` | `NUMBER` | Identifier for the queue
`QUEUE_SCHEMA` | `VARCHAR2(30)` | Schema of the queue
`QUEUE_NAME` | `VARCHAR2(30)` | Name of the queue
`SUBSCRIBER_ID` | `NUMBER` | Internal subscriber number (for identification)
`SUBSCRIBER_NAME` | `VARCHAR2(30)` | Name of the subscriber (comparable to the Streams name for the Streams process)
`SUBSCRIBER_ADDRESS` | `VARCHAR2(1024)` | Address of the subscribing agent
`PROTOCOL` | `NUMBER` | Protocol of the subscribing agent
`SUBSCRIBER_TYPE` | `VARCHAR2(30)` | Type of the subscriber: `PROXY` - Proxy subscriber `SUBSCRIBER`
`STARTUP_TIME` | `DATE` | Startup time
`LAST_BROWSED_SEQ` | `NUMBER` | Sequence number of the most recently browsed message for the subscriber (comparable to the number of messages in the `V$STREAMS_APPLY_READER` view)
`LAST_BROWSED_NUM` | `NUMBER` | Internal Message number for the most recently browsed message for the subscriber
`LAST_DEQUEUED_SEQ` | `NUMBER` | Sequence number of the most recently dequeued message for the subscriber (comparable to the number of messages in the `V$STREAMS_APPLY_COORDINATOR` view)
`LAST_DEQUEUED_NUM` | `NUMBER` | Internal Message number for the most recently dequeued message for the subscriber
`CURRENT_ENQ_SEQ` | `NUMBER` | Current sequence number of the most recently enqueued message for the subscriber
`NUM_MSGS` | `NUMBER` | Total number of outstanding messages currently enqueued in the buffered queue for the subscriber (includes the count of the messages overflowed to disk)
`CNUM_MSGS` | `NUMBER` | Cumulative total number of messages enqueued for the subscriber since the database last started
`TOTAL_DEQUEUED_MSG` | `NUMBER` | Total number of messages dequeued by the subscriber
`TOTAL_SPILLED_MSG` | `NUMBER` | Total number of spilled messages for the subscriber
`EXPIRED_MSGS` | `NUMBER` | Number of expired messages